inherited frmPosGrantVoucherBill: TfrmPosGrantVoucherBill
  Caption = #21457#25918#25269#29992#21048
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    inherited pnlThirdtrade: TPanel
      inherited edtTTtraderid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTtraderid: TcxLabel
        AnchorX = 78
      end
      inherited cxLabel1: TcxLabel
        AnchorX = 262
      end
      inherited edtTTamount: TcxDBCalcEdit
        ExplicitHeight = 21
      end
      inherited edtTTremark: TcxDBTextEdit
        ExplicitHeight = 21
      end
      inherited edtTTBalanceid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited edtTTAccountid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTBalanceid: TcxLabel
        AnchorX = 469
      end
      inherited edtTTBalanceamt: TcxDBCalcEdit
        ExplicitHeight = 21
      end
    end
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited edtDate: TcxDBDateEdit
      ExplicitHeight = 21
    end
    inherited edtCode: TcxDBTextEdit
      ExplicitHeight = 21
    end
    inherited DtlPageCtrl: TcxPageControl
      TabOrder = 7
      inherited tabMain: TcxTabSheet
        ExplicitWidth = 0
        ExplicitHeight = 0
      end
    end
    inherited edtCreate_time: TcxDBTimeEdit
      ExplicitHeight = 21
    end
    inherited imgCheck: TcxImage
      TabOrder = 6
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynedtCreate_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynedtCheck_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynedtFilid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynedtDeptid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynedtEmpid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
    inherited dynedtBKind: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited pnlTop: TPanel
    inherited edtPrint: TcxLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited pnlBottom: TPanel
    inherited barBill: TcxProgressBar
      ExplicitHeight = 21
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
  end
  inherited qryDetail: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posgrantvoucherdtl'
      
        '  (bid, bno, vouchertypeid, facevalue, startno, endno, quantity,' +
        ' amount, startdate, enddate, explan, custom1, custom2, custom3, ' +
        'custom4, custom5, custom6, custom7, custom8, custom9, custom10, ' +
        'custom11, custom12, custom13, custom14, custom15, relationcount,' +
        ' relationbid, relationbtype, relationbno)'
      'VALUES'
      
        '  (:bid, :bno, :vouchertypeid, :facevalue, :startno, :endno, :qu' +
        'antity, :amount, :startdate, :enddate, :explan, :custom1, :custo' +
        'm2, :custom3, :custom4, :custom5, :custom6, :custom7, :custom8, ' +
        ':custom9, :custom10, :custom11, :custom12, :custom13, :custom14,' +
        ' :custom15, :relationcount, :relationbid, :relationbtype, :relat' +
        'ionbno)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posgrantvoucherdtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLUpdate.Strings = (
      'UPDATE tb_posgrantvoucherdtl'
      'SET'
      
        '  bid = :bid, bno = :bno, vouchertypeid = :vouchertypeid, faceva' +
        'lue = :facevalue, startno = :startno, endno = :endno, quantity =' +
        ' :quantity, amount = :amount, startdate = :startdate, enddate = ' +
        ':enddate, explan = :explan, custom1 = :custom1, custom2 = :custo' +
        'm2, custom3 = :custom3, custom4 = :custom4, custom5 = :custom5, ' +
        'custom6 = :custom6, custom7 = :custom7, custom8 = :custom8, cust' +
        'om9 = :custom9, custom10 = :custom10, custom11 = :custom11, cust' +
        'om12 = :custom12, custom13 = :custom13, custom14 = :custom14, cu' +
        'stom15 = :custom15, relationcount = :relationcount, relationbid ' +
        '= :relationbid, relationbtype = :relationbtype, relationbno = :r' +
        'elationbno'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLLock.Strings = (
      'SELECT * FROM tb_posgrantvoucherdtl'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRefresh.Strings = (
      
        'SELECT bid, bno, vouchertypeid, facevalue, startno, endno, quant' +
        'ity, amount, startdate, enddate, explan, custom1, custom2, custo' +
        'm3, custom4, custom5, custom6, custom7, custom8, custom9, custom' +
        '10, custom11, custom12, custom13, custom14, custom15, relationco' +
        'unt, relationbid, relationbtype, relationbno FROM tb_posgrantvou' +
        'cherdtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posgrantvoucherdtl'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posgrantvoucherdtl')
  end
  inherited MainDataSet: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posgrantvoucher'
      
        '  (bid, bdate, bkind, bcode, bstate, isexchangescore, memberid, ' +
        'cutscore, voucherid, remark, filid, deptid, modifierid, create_b' +
        'y, check_by, create_time, update_time, custom1, custom2, custom3' +
        ', custom4, custom5, custom6, custom7, custom8, custom9, custom10' +
        ', custom11, custom12, custom13, custom14, custom15, relationcoun' +
        't, empid, check_time)'
      'VALUES'
      
        '  (:bid, :bdate, :bkind, :bcode, :bstate, :isexchangescore, :mem' +
        'berid, :cutscore, :voucherid, :remark, :filid, :deptid, :modifie' +
        'rid, :create_by, :check_by, :create_time, :update_time, :custom1' +
        ', :custom2, :custom3, :custom4, :custom5, :custom6, :custom7, :c' +
        'ustom8, :custom9, :custom10, :custom11, :custom12, :custom13, :c' +
        'ustom14, :custom15, :relationcount, :empid, :check_time)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posgrantvoucher'
      'WHERE'
      '  bid = :Old_bid')
    SQLUpdate.Strings = (
      'UPDATE tb_posgrantvoucher'
      'SET'
      
        '  bid = :bid, bdate = :bdate, bkind = :bkind, bcode = :bcode, bs' +
        'tate = :bstate, isexchangescore = :isexchangescore, memberid = :' +
        'memberid, cutscore = :cutscore, voucherid = :voucherid, remark =' +
        ' :remark, filid = :filid, deptid = :deptid, modifierid = :modifi' +
        'erid, create_by = :create_by, check_by = :check_by, create_time ' +
        '= :create_time, update_time = :update_time, custom1 = :custom1, ' +
        'custom2 = :custom2, custom3 = :custom3, custom4 = :custom4, cust' +
        'om5 = :custom5, custom6 = :custom6, custom7 = :custom7, custom8 ' +
        '= :custom8, custom9 = :custom9, custom10 = :custom10, custom11 =' +
        ' :custom11, custom12 = :custom12, custom13 = :custom13, custom14' +
        ' = :custom14, custom15 = :custom15, relationcount = :relationcou' +
        'nt, empid = :empid, check_time = :check_time'
      'WHERE'
      '  bid = :Old_bid')
    SQLLock.Strings = (
      'SELECT * FROM tb_posgrantvoucher'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid')
    SQLRefresh.Strings = (
      
        'SELECT bid, bdate, bkind, bcode, bstate, isexchangescore, member' +
        'id, cutscore, voucherid, remark, filid, deptid, modifierid, crea' +
        'te_by, check_by, create_time, update_time, custom1, custom2, cus' +
        'tom3, custom4, custom5, custom6, custom7, custom8, custom9, cust' +
        'om10, custom11, custom12, custom13, custom14, custom15, relation' +
        'count, empid, check_time FROM tb_posgrantvoucher'
      'WHERE'
      '  bid = :Old_bid')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posgrantvoucher'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posgrantvoucher')
  end
end
